MS Excel as Tool for Modeling, Dynamic Simulation and Visualization of Mathematical Functions
نویسندگان
چکیده
One of the most important tasks in teaching of mathematics is to use a suitable method for developing of theoretically acquired knowledge. Drawing on his own experience, the authors have found that the best method to be used is the system approach. System approach is closely connected to the modeling and simulation. Theory of the systems, modeling and simulation are disciplines with its own theory and research methodology. Modeling and computer simulation can be understand as one of the most important method in teaching of mathematics and simultaneously can be use as suitable method for practical developing of theoretically acquired knowledge. Case study, described in the paper, presents possibility of dynamic visualization of mathematical function. The solution is demonstrated in MS Excel worksheet and chart. Key-Words: Animation, computer simulation, mathematical modeling, system approach, visualization.
منابع مشابه
Hybrid Time Delay Petri Nets as a Mathematical Novel Tool to Model Dynamic System with Current Sample Time
The existing modeling methods using Petri Nets, have been successfully applied to model and analyze dynamic systems. However, these methods are not capable of modeling all dynamic systems such as systems with the current sample time signals, systems including various subsystems and multi-mode systems. This paper proposes Hybrid Time Delay Petri Nets (HTDPN) to solve the problem. In ...
متن کاملExtension of Higher Order Derivatives of Lyapunov Functions in Stability Analysis of Nonlinear Systems
The Lyapunov stability method is the most popular and applicable stability analysis tool of nonlinear dynamic systems. However, there are some bottlenecks in the Lyapunov method, such as need for negative definiteness of the Lyapunov function derivative in the direction of the system’s solutions. In this paper, we develop a new theorem to dispense the need for negative definite-ness of Lyapunov...
متن کاملModelsaz: An Object-Oriented Computer-Aided Modeling Environment
Modeling and simulation of processing plants are widely used in industry. Construction of a mathematical model for a plant is a time-consuming and error-prone task. In light of extensive advancements in computer science (both hardware and software), computers are becoming a necessary instrument in industrial activities. Many software tools for modeling, simulation and optimization of proces...
متن کاملFurthermore the use of lupine flour and products from Lupine protein and hydrolysates in the production of a wide range of so-called gluten-free products cannot be omitted- Lupine does not contain gluten. II. HYDROLYSIS OF PROTEINS
Abstract—The paper focuses to the process of modeling and computer simulation of the real experiment. Step by step there is shown system identification and creation of mathematical model of determination of optimum reaction time of whey acidic for the hydrolysis of proteins of lupine flour. Computer simulation model created in MS Excel spreadsheet and visualized in MS Excel XYZ surface chart is...
متن کاملData Envelopment Analysis with LINGO Modeling for Technical Educational Group of an Organization
Data Envelopment Analysis (DEA) was developed to help compare the relative performance of decision-making units. It is a non-parametric method for performing frontier analysis. It uses linear programming to estimate the efficiency of multiple decision-making units and it is commonly used in production, management and economics [3]. DEA generates an efficiency score between 0 and 1 for each unit...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2012